/**
 * UserInfoTableMetaData.java
 * com.jamin.aabill.db
 *
 * Function： TODO 
 *
 *   ver     date      		author
 * ──────────────────────────────────
 *   		 2012-8-20 		wangjieming
 *
 * Copyright (c) 2012, TNT All Rights Reserved.
 */

package com.jamin.aabill.db;

import android.provider.BaseColumns;

/**
 * ClassName:UserInfoTableMetaData
 *
 * @author   wangjieming
 * @version  1.0
 * @since    v1.0
 * @Date	 2012-8-20 上午9:19:50 
 */
public class UserInfoTableMetaData  implements BaseColumns {



	public static final String TABLE_NAME = "userinfo";
	public static final String NICK_NAME = "nickname";
	public static final String EMAIL = "email";
	public static final String MOBILE = "mobile";
	public static final String PASSWORD = "password";
	public static final String CREATE_AT = "create_at";
	public static final String LAST_LOGIN_AT = "last_login_at";


	public static final String CREATE_TABLE_SQL = "CREATE TABLE IF NOT EXISTS "
			+ TABLE_NAME + "(" 
			+ _ID+ " INTEGER PRIMARY KEY," 
			+ NICK_NAME+ " TEXT," 
			+ EMAIL + " TEXT,"
			+ MOBILE + " TEXT,"
			+ PASSWORD + " TEXT,"
			+ CREATE_AT + " INTEGER,"
			+ LAST_LOGIN_AT + " INTEGER"
			+ ");";



	public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS "+ TABLE_NAME;




}

